<?php
session_start();
/*
 * Session variables:
 * $_SESSION['type'] [string] = user type of the logged in user
 * $_SESSION['authorised'] [boolean] = whether or not the current user is logged in
 */
if (isset($_SESSION['authorised']) && $_SESSION['authorised'] == true) {
	if (isset($_SESSION['type'])) {
		if ($_SESSION['type'] == 'administrator') {
			?>
<html xmlns="http://www.w3.org/1999/xhtml">
<head>

<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Transaction Creation</title>
<link href="StyleSheet.css" rel="stylesheet" type="text/css" />
<style>
.nav {
	width: 210px;
	height: auto;
	border: thin solid #09C;
	margin-left: 10px;
	text-align: center;
}

.mainline {
	width: 712px;
	height: auto;
	text-align: center;
}
</style>
<script>
					         function LimitText(AId,BId)
					         {
					          var e1 = document.getElementById(AId);
					          var e2 = document.getElementById(BId);
					          var l1 = e1.value.length;
					          (l1 > 250)?e1.value = e1.value.substring(0,1000):e2.innerHTML = 250 - l1 
					         }
					      </script>
</head>

<center>
	<body bgcolor="#FFFFFF">
		<div id="wrapper">
			<div id="header">
				<h1></h1>
			</div>

			<div id="header2">
				<h3></h3>
			</div>


			<div id="nav">
				<h4>Navigation</h4>
				<center>
					<script src="adminjs.js" type="text/javascript"></script>
					<noscript>
						<OBJECT id="adminobj"
							classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000"
							codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=5,0,0,0"
							WIDTH=230 HEIGHT=280>
							<PARAM NAME=movie VALUE="admin.swf">
							<PARAM NAME=menu VALUE=false>
							<PARAM NAME=quality VALUE=high>
							<PARAM NAME=wmode VALUE=opaque>
							<param name="scale" value="noscale" />
							<PARAM NAME=bgcolor VALUE=#FFFFFF>
							<EMBED src="admin.swf" menu=false quality=high scale="noscale"
								wmode=opaque bgcolor=#FFFFFF WIDTH=230 HEIGHT=280
								TYPE="application/x-shockwave-flash"
								PLUGINSPAGE="http://www.macromedia.com/shockwave/download/index.cgi?P1_Prod_Version=ShockwaveFlash"></EMBED>
						</OBJECT>
					</noscript>
				</center>
			</div>

			<div id="mainline">
				<h4>Create Transaction</h4>
				<div id="body">
					<form action="admin_addingtransaction.php" method="post">
						<table width="712" cellpadding="2" class="infotable" align="left">
							<tr align="left">
								<th height="42" scope="row">Paid by / to:</th>
								<td><select name="paid_by">
								<?php
								include('connection.inc');
									
								$sql = "SELECT username, usertype, lastname || ', ' ||firstname AS user FROM users order by lastname, firstname";
								$result = pg_query($sql);
								for($i = 0; $i < pg_num_rows($result); $i++)
								{
									$paid_by = pg_fetch_result($result, $i, 'user');
									$username = pg_fetch_result($result, $i, 'username');
									$type = pg_fetch_result($result, $i, 'usertype');
									if($type=='student' || $type=='tutor')
									{
										echo "<option value = \"$username\">$paid_by</option>";
									}
								}
								?>
								</select>
								</td>
							</tr>
							<tr align="left">
								<th height="42" scope="row">Amount (in Php):</th>
								<td><input type="text" size="20" maxlength="18" id="amount"
									name="amount" />
								</td>
							</tr>
							<!-- tr align="left">
								<th height="42" scope="row">Paid Tag</th>
								<td>
									<input type="checkbox" name="paid_tag" value="true" />
								</td>
							</tr-->
							<tr align="left" valign="top">
								<th height="42" scope="row">Description:</th>
								<td><textarea name="description" id="description" rows="5"
										cols="50" onkeyup="LimitText('description','cleft')"
										onblur="LimitText('description','cleft')"></textarea></td>
								</td>
							</tr>
							<tr align="left">
								<td></td>
								<td><label id="cleft" style="font-size: 13">250</label> <label
									style="font-size: 12">Characters Left</label> <input
									type="submit" value="Submit" /></td>
							</tr>
						</table>
					</form>

					<p align="justify">
						<br />
					</p>
				</div>

				<br class="clearfloat" /> <br />

			</div>
			<div id="footer">
				<p align="center">
					Tutorial Business Manager: info@tbms.com <br />Credits/Engineers:
					Aquino, Chloebelle; Dela Cruz, Roy Erwin; Maliwanag, Ranyel Bryan;
					Manzano, Audrey Ann; Ng, Sheila Regine<br /> <br />copyright 2011
				</p>
			</div>
		</div>
	</body>
</center>
</html>
								<?php
		} elseif ($_SESSION['type'] == 'student') {
			header('Location: student_index.php');
			exit();
		} elseif ($_SESSION['type'] == 'tutor') {
			header('Location: tutor_index.php');
			exit();
		} elseif ($_SESSION['type'] == 'parent') {
			header('Location: parent_index.php');
			exit();
		}
	}
} else {
	header('Location: index.php');
}
?>
